create table qrtz_blob_triggers
(
    sched_name    nvarchar(120) not null,
    trigger_name  nvarchar(200) not null,
    trigger_group nvarchar(200) not null,
    blob_data     varbinary(max),
    primary key (sched_name, trigger_name, trigger_group),
    constraint qrtz_blob_triggers_ibfk_1
        foreign key (sched_name, trigger_name, trigger_group) references qrtz_triggers
)
go

exec sp_addextendedproperty 'MS_Description', 'Blob类型的触发器表', 'SCHEMA', 'dbo', 'TABLE', 'qrtz_blob_triggers'
go

exec sp_addextendedproperty 'MS_Description', '调度名称', 'SCHEMA', 'dbo', 'TABLE', 'qrtz_blob_triggers', 'COLUMN',
     'sched_name'
go

exec sp_addextendedproperty 'MS_Description', 'qrtz_triggers表trigger_name的外键', 'SCHEMA', 'dbo', 'TABLE',
     'qrtz_blob_triggers', 'COLUMN', 'trigger_name'
go

exec sp_addextendedproperty 'MS_Description', 'qrtz_triggers表trigger_group的外键', 'SCHEMA', 'dbo', 'TABLE',
     'qrtz_blob_triggers', 'COLUMN', 'trigger_group'
go

exec sp_addextendedproperty 'MS_Description', '存放持久化Trigger对象', 'SCHEMA', 'dbo', 'TABLE', 'qrtz_blob_triggers',
     'COLUMN', 'blob_data'
go

